package com.ciko.code.logic.table;

import android.provider.BaseColumns;


/**
 * 联系人分组信息表
 */
public class ContactGroupTable {
    public static  String table = "t_contact_group";

    public final class SuperColums implements BaseColumns {
        /**
         * 分组编号
         */
        public final static String GROUP_ID = "groupId";
        /**
         * 是否删除 y=是 n=否
         */
        public final static String IS_DELETE = "isDelete";
        /**
         * 分组名称
         */
        public final static String NAME = "name";
        /**
         * 分组排序号
         */
        public final static String SORT_NUM = "sortNum";
        /**
         * 公司id
         */
        public final static String COMPANY_ID = "companyId";
    }

    public static String getCreateTableSQL() {
        StringBuilder sb = new StringBuilder();
        sb.append("CREATE TABLE IF NOT EXISTS " + table + "(");
        sb.append(SuperColums.GROUP_ID + " INTEGER,");
        sb.append(SuperColums.IS_DELETE + " VARCHAR(10),");
        sb.append(SuperColums.NAME + " VARCHAR(50),");
        sb.append(SuperColums.COMPANY_ID + " INTEGER,");
        sb.append(SuperColums.SORT_NUM + " INTEGER");
        sb.append(");");
        return sb.toString();
    }
}
